USE [TagsDb]
GO

CREATE TABLE [dbo].[Settings](
	[LoadingFileID] [bigint] NULL,
	[LoadingFileStage] [tinyint] NULL,
	[LoadingFileDtMin] [datetime] NULL,
	[LoadingFileDtMax] [datetime] NULL,
	--[LoadedFileDtMax] [datetime] NULL,
	[LoadedBorder1] [datetime] NULL,
	[LoadedBorder2] [datetime] NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[TagsTI](
	[Dt] [datetime] NOT NULL,
	[FixDt] [datetime] NOT NULL,
	[Ch] [tinyint] NOT NULL,
	[RTU] [tinyint] NOT NULL,
	[Point] [smallint] NOT NULL,
	[Value] [real] NOT NULL,
	[Flags] [smallint] NOT NULL,
	[FlagsHi] [smallint] NOT NULL,
	[trid] [tinyint] NOT NULL,
) ON [PRIMARY]

CREATE TABLE [dbo].[TagsTS](
	[Dt] [datetime] NOT NULL,
	[FixDt] [datetime] NOT NULL,
	[Ch] [tinyint] NOT NULL,
	[RTU] [tinyint] NOT NULL,
	[Point] [smallint] NOT NULL,
	[Value] [tinyint] NOT NULL,
	[Flags] [smallint] NOT NULL,
	[FlagsHi] [smallint] NOT NULL,
	[S2] [smallint] NOT NULL,
	[trid] [tinyint] NOT NULL,
) ON [PRIMARY]

CREATE TABLE [dbo].[AggrDef](
	[Id] [tinyint] NOT NULL,
	[SpanUnit] [varchar](50) NOT NULL,
	[SpanValue] [tinyint] NOT NULL,
	[LoadedBorder1] [datetime] NULL,
	[LoadedBorder2] [datetime] NULL,
) ON [PRIMARY]

CREATE TABLE [dbo].[Aggr001](
	[Border1] [datetime] NOT NULL,
	[Ch] [smallint] NOT NULL,
	[RTU] [smallint] NOT NULL,
	[Point] [smallint] NOT NULL,
	[ValueMin] [real] NOT NULL,
	[ValueMax] [real] NOT NULL,
	[ValueAvg] [real] NOT NULL,
 CONSTRAINT [PK_Aggr001] PRIMARY KEY CLUSTERED 
(
	[Border1] ASC,
	[Ch] ASC,
	[RTU] ASC,
	[Point] ASC
)
)
